{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "16\n",
      "780\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>bench</th>\n",
       "      <th>DB</th>\n",
       "      <th>scale</th>\n",
       "      <th>terminals</th>\n",
       "      <th>test-item</th>\n",
       "      <th>result</th>\n",
       "      <th>unit</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q1</td>\n",
       "      <td>1155</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q8</td>\n",
       "      <td>63</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q15</td>\n",
       "      <td>76</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q20</td>\n",
       "      <td>42</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q21</td>\n",
       "      <td>328</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q22</td>\n",
       "      <td>33</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q1</td>\n",
       "      <td>1145</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q8</td>\n",
       "      <td>88</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q15</td>\n",
       "      <td>68</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q20</td>\n",
       "      <td>32</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q21</td>\n",
       "      <td>299</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q22</td>\n",
       "      <td>32</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q1</td>\n",
       "      <td>1139</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q8</td>\n",
       "      <td>94</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q15</td>\n",
       "      <td>59</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q20</td>\n",
       "      <td>29</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q21</td>\n",
       "      <td>299</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q22</td>\n",
       "      <td>32</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q1</td>\n",
       "      <td>1125</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q8</td>\n",
       "      <td>88</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q15</td>\n",
       "      <td>60</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q20</td>\n",
       "      <td>29</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q21</td>\n",
       "      <td>303</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q22</td>\n",
       "      <td>32</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q1</td>\n",
       "      <td>1123</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q8</td>\n",
       "      <td>93</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q15</td>\n",
       "      <td>59</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q20</td>\n",
       "      <td>29</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q21</td>\n",
       "      <td>305</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q22</td>\n",
       "      <td>33</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>750</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q1</td>\n",
       "      <td>23338</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>751</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q8</td>\n",
       "      <td>2254</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>752</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q15</td>\n",
       "      <td>4623</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>753</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q20</td>\n",
       "      <td>1580</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>754</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q21</td>\n",
       "      <td>10786</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>755</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q22</td>\n",
       "      <td>349</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>756</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q1</td>\n",
       "      <td>23485</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>757</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q8</td>\n",
       "      <td>2256</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>758</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q15</td>\n",
       "      <td>4613</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>759</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q20</td>\n",
       "      <td>1560</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q21</td>\n",
       "      <td>10699</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>761</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q22</td>\n",
       "      <td>348</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>762</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q1</td>\n",
       "      <td>23240</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>763</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q8</td>\n",
       "      <td>2236</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>764</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q15</td>\n",
       "      <td>4586</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>765</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q20</td>\n",
       "      <td>1578</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>766</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q21</td>\n",
       "      <td>10751</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>767</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q22</td>\n",
       "      <td>348</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>768</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q1</td>\n",
       "      <td>23090</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>769</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q8</td>\n",
       "      <td>2221</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>770</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q15</td>\n",
       "      <td>4617</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>771</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q20</td>\n",
       "      <td>1571</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>772</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q21</td>\n",
       "      <td>10735</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>773</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q22</td>\n",
       "      <td>353</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>774</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q1</td>\n",
       "      <td>23407</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q8</td>\n",
       "      <td>2225</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>776</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q15</td>\n",
       "      <td>4549</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>777</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q20</td>\n",
       "      <td>1580</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q21</td>\n",
       "      <td>10761</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mysql</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q22</td>\n",
       "      <td>349</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>780 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     bench     DB scale terminals test-item result unit\n",
       "0    tpc-h  mysql   0.1        T1        Q1   1155   ms\n",
       "1    tpc-h  mysql   0.1        T1        Q8     63   ms\n",
       "2    tpc-h  mysql   0.1        T1       Q15     76   ms\n",
       "3    tpc-h  mysql   0.1        T1       Q20     42   ms\n",
       "4    tpc-h  mysql   0.1        T1       Q21    328   ms\n",
       "5    tpc-h  mysql   0.1        T1       Q22     33   ms\n",
       "6    tpc-h  mysql   0.1        T1        Q1   1145   ms\n",
       "7    tpc-h  mysql   0.1        T1        Q8     88   ms\n",
       "8    tpc-h  mysql   0.1        T1       Q15     68   ms\n",
       "9    tpc-h  mysql   0.1        T1       Q20     32   ms\n",
       "10   tpc-h  mysql   0.1        T1       Q21    299   ms\n",
       "11   tpc-h  mysql   0.1        T1       Q22     32   ms\n",
       "12   tpc-h  mysql   0.1        T1        Q1   1139   ms\n",
       "13   tpc-h  mysql   0.1        T1        Q8     94   ms\n",
       "14   tpc-h  mysql   0.1        T1       Q15     59   ms\n",
       "15   tpc-h  mysql   0.1        T1       Q20     29   ms\n",
       "16   tpc-h  mysql   0.1        T1       Q21    299   ms\n",
       "17   tpc-h  mysql   0.1        T1       Q22     32   ms\n",
       "18   tpc-h  mysql   0.1        T1        Q1   1125   ms\n",
       "19   tpc-h  mysql   0.1        T1        Q8     88   ms\n",
       "20   tpc-h  mysql   0.1        T1       Q15     60   ms\n",
       "21   tpc-h  mysql   0.1        T1       Q20     29   ms\n",
       "22   tpc-h  mysql   0.1        T1       Q21    303   ms\n",
       "23   tpc-h  mysql   0.1        T1       Q22     32   ms\n",
       "24   tpc-h  mysql   0.1        T1        Q1   1123   ms\n",
       "25   tpc-h  mysql   0.1        T1        Q8     93   ms\n",
       "26   tpc-h  mysql   0.1        T1       Q15     59   ms\n",
       "27   tpc-h  mysql   0.1        T1       Q20     29   ms\n",
       "28   tpc-h  mysql   0.1        T1       Q21    305   ms\n",
       "29   tpc-h  mysql   0.1        T1       Q22     33   ms\n",
       "..     ...    ...   ...       ...       ...    ...  ...\n",
       "750  tpc-h  mysql   2.0        T1        Q1  23338   ms\n",
       "751  tpc-h  mysql   2.0        T1        Q8   2254   ms\n",
       "752  tpc-h  mysql   2.0        T1       Q15   4623   ms\n",
       "753  tpc-h  mysql   2.0        T1       Q20   1580   ms\n",
       "754  tpc-h  mysql   2.0        T1       Q21  10786   ms\n",
       "755  tpc-h  mysql   2.0        T1       Q22    349   ms\n",
       "756  tpc-h  mysql   2.0        T1        Q1  23485   ms\n",
       "757  tpc-h  mysql   2.0        T1        Q8   2256   ms\n",
       "758  tpc-h  mysql   2.0        T1       Q15   4613   ms\n",
       "759  tpc-h  mysql   2.0        T1       Q20   1560   ms\n",
       "760  tpc-h  mysql   2.0        T1       Q21  10699   ms\n",
       "761  tpc-h  mysql   2.0        T1       Q22    348   ms\n",
       "762  tpc-h  mysql   2.0        T1        Q1  23240   ms\n",
       "763  tpc-h  mysql   2.0        T1        Q8   2236   ms\n",
       "764  tpc-h  mysql   2.0        T1       Q15   4586   ms\n",
       "765  tpc-h  mysql   2.0        T1       Q20   1578   ms\n",
       "766  tpc-h  mysql   2.0        T1       Q21  10751   ms\n",
       "767  tpc-h  mysql   2.0        T1       Q22    348   ms\n",
       "768  tpc-h  mysql   2.0        T1        Q1  23090   ms\n",
       "769  tpc-h  mysql   2.0        T1        Q8   2221   ms\n",
       "770  tpc-h  mysql   2.0        T1       Q15   4617   ms\n",
       "771  tpc-h  mysql   2.0        T1       Q20   1571   ms\n",
       "772  tpc-h  mysql   2.0        T1       Q21  10735   ms\n",
       "773  tpc-h  mysql   2.0        T1       Q22    353   ms\n",
       "774  tpc-h  mysql   2.0        T1        Q1  23407   ms\n",
       "775  tpc-h  mysql   2.0        T1        Q8   2225   ms\n",
       "776  tpc-h  mysql   2.0        T1       Q15   4549   ms\n",
       "777  tpc-h  mysql   2.0        T1       Q20   1580   ms\n",
       "778  tpc-h  mysql   2.0        T1       Q21  10761   ms\n",
       "779  tpc-h  mysql   2.0        T1       Q22    349   ms\n",
       "\n",
       "[780 rows x 7 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "def txt2xlsx(file, column =[]):\n",
    "    with open(file, 'r') as raw:\n",
    "        count = 0\n",
    "        data = []\n",
    "        for line in raw.readlines():\n",
    "            data.append(line.strip().split('\\t'))\n",
    "            count = count + 1\n",
    "        print(count)\n",
    "        df = pd.DataFrame(data, columns=column)\n",
    "        writer = pd.ExcelWriter(file[::-1][4:][::-1] + '.xlsx')\n",
    "        df.to_excel(writer, 'Sheet1', index = False)\n",
    "        writer.save()\n",
    "        return df\n",
    "txt2xlsx('loadResults-MySQL.txt', ['bench', 'DB', 'scale', 'test-item', 'result', 'unit'])\n",
    "txt2xlsx('queryResults-MySQL.txt', ['bench', 'DB', 'scale', 'terminals', 'test-item', 'result', 'unit'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "16\n",
      "295\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>bench</th>\n",
       "      <th>DB</th>\n",
       "      <th>scale</th>\n",
       "      <th>terminals</th>\n",
       "      <th>test-item</th>\n",
       "      <th>result</th>\n",
       "      <th>unit</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q8</td>\n",
       "      <td>286</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q15</td>\n",
       "      <td>138</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q20</td>\n",
       "      <td>430</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q21</td>\n",
       "      <td>2523</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q22</td>\n",
       "      <td>4227</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q1</td>\n",
       "      <td>1622</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q8</td>\n",
       "      <td>271</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q15</td>\n",
       "      <td>110</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q20</td>\n",
       "      <td>427</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q21</td>\n",
       "      <td>2220</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q22</td>\n",
       "      <td>4141</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q1</td>\n",
       "      <td>1599</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q8</td>\n",
       "      <td>252</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q15</td>\n",
       "      <td>113</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q20</td>\n",
       "      <td>399</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q21</td>\n",
       "      <td>2119</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q22</td>\n",
       "      <td>4128</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q1</td>\n",
       "      <td>1591</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q8</td>\n",
       "      <td>252</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q15</td>\n",
       "      <td>113</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q20</td>\n",
       "      <td>400</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q21</td>\n",
       "      <td>2089</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q22</td>\n",
       "      <td>4128</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q1</td>\n",
       "      <td>1602</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q8</td>\n",
       "      <td>254</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q15</td>\n",
       "      <td>119</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q20</td>\n",
       "      <td>407</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q21</td>\n",
       "      <td>2046</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q22</td>\n",
       "      <td>4132</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>0.1</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q1</td>\n",
       "      <td>1606</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>265</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>1.0</td>\n",
       "      <td>T6</td>\n",
       "      <td>Q20</td>\n",
       "      <td>69954</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>266</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>1.0</td>\n",
       "      <td>T6</td>\n",
       "      <td>Q21</td>\n",
       "      <td>55117</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>267</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>1.0</td>\n",
       "      <td>T6</td>\n",
       "      <td>Q22</td>\n",
       "      <td>84589</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>268</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>1.0</td>\n",
       "      <td>T6</td>\n",
       "      <td>Q15</td>\n",
       "      <td>15465</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>269</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>1.0</td>\n",
       "      <td>T6</td>\n",
       "      <td>Q1</td>\n",
       "      <td>325275</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>1.0</td>\n",
       "      <td>T6</td>\n",
       "      <td>Q8</td>\n",
       "      <td>83817</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>1.0</td>\n",
       "      <td>T6</td>\n",
       "      <td>Q20</td>\n",
       "      <td>89752</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>1.0</td>\n",
       "      <td>T6</td>\n",
       "      <td>Q21</td>\n",
       "      <td>55608</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>1.0</td>\n",
       "      <td>T6</td>\n",
       "      <td>Q22</td>\n",
       "      <td>86394</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>1.0</td>\n",
       "      <td>T6</td>\n",
       "      <td>Q15</td>\n",
       "      <td>16812</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>275</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>1.0</td>\n",
       "      <td>T6</td>\n",
       "      <td>Q15</td>\n",
       "      <td>10563</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>1.0</td>\n",
       "      <td>T6</td>\n",
       "      <td>Q1</td>\n",
       "      <td>249321</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>277</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>1.0</td>\n",
       "      <td>T6</td>\n",
       "      <td>Q8</td>\n",
       "      <td>62561</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>1.0</td>\n",
       "      <td>T6</td>\n",
       "      <td>Q20</td>\n",
       "      <td>69955</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>1.0</td>\n",
       "      <td>T6</td>\n",
       "      <td>Q21</td>\n",
       "      <td>55134</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>280</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>1.0</td>\n",
       "      <td>T6</td>\n",
       "      <td>Q22</td>\n",
       "      <td>84533</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>281</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>1.0</td>\n",
       "      <td>T6</td>\n",
       "      <td>Q15</td>\n",
       "      <td>15453</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>1.0</td>\n",
       "      <td>T6</td>\n",
       "      <td>Q1</td>\n",
       "      <td>325324</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>283</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>1.0</td>\n",
       "      <td>T6</td>\n",
       "      <td>Q8</td>\n",
       "      <td>83812</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>1.0</td>\n",
       "      <td>T6</td>\n",
       "      <td>Q20</td>\n",
       "      <td>89756</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>1.0</td>\n",
       "      <td>T6</td>\n",
       "      <td>Q21</td>\n",
       "      <td>55610</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>286</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>1.0</td>\n",
       "      <td>T6</td>\n",
       "      <td>Q22</td>\n",
       "      <td>86377</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>1.0</td>\n",
       "      <td>T6</td>\n",
       "      <td>Q15</td>\n",
       "      <td>16793</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>288</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q15</td>\n",
       "      <td>42953</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q1</td>\n",
       "      <td>888742</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>290</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q8</td>\n",
       "      <td>194269</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q20</td>\n",
       "      <td>284587</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>292</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q21</td>\n",
       "      <td>117424</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>293</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q22</td>\n",
       "      <td>179180</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>294</th>\n",
       "      <td>tpc-h</td>\n",
       "      <td>mongo</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T1</td>\n",
       "      <td>Q15</td>\n",
       "      <td>46968</td>\n",
       "      <td>ms</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>295 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     bench     DB scale terminals test-item  result unit\n",
       "0    tpc-h  mongo   0.1        T1        Q8     286   ms\n",
       "1    tpc-h  mongo   0.1        T1       Q15     138   ms\n",
       "2    tpc-h  mongo   0.1        T1       Q20     430   ms\n",
       "3    tpc-h  mongo   0.1        T1       Q21    2523   ms\n",
       "4    tpc-h  mongo   0.1        T1       Q22    4227   ms\n",
       "5    tpc-h  mongo   0.1        T1        Q1    1622   ms\n",
       "6    tpc-h  mongo   0.1        T1        Q8     271   ms\n",
       "7    tpc-h  mongo   0.1        T1       Q15     110   ms\n",
       "8    tpc-h  mongo   0.1        T1       Q20     427   ms\n",
       "9    tpc-h  mongo   0.1        T1       Q21    2220   ms\n",
       "10   tpc-h  mongo   0.1        T1       Q22    4141   ms\n",
       "11   tpc-h  mongo   0.1        T1        Q1    1599   ms\n",
       "12   tpc-h  mongo   0.1        T1        Q8     252   ms\n",
       "13   tpc-h  mongo   0.1        T1       Q15     113   ms\n",
       "14   tpc-h  mongo   0.1        T1       Q20     399   ms\n",
       "15   tpc-h  mongo   0.1        T1       Q21    2119   ms\n",
       "16   tpc-h  mongo   0.1        T1       Q22    4128   ms\n",
       "17   tpc-h  mongo   0.1        T1        Q1    1591   ms\n",
       "18   tpc-h  mongo   0.1        T1        Q8     252   ms\n",
       "19   tpc-h  mongo   0.1        T1       Q15     113   ms\n",
       "20   tpc-h  mongo   0.1        T1       Q20     400   ms\n",
       "21   tpc-h  mongo   0.1        T1       Q21    2089   ms\n",
       "22   tpc-h  mongo   0.1        T1       Q22    4128   ms\n",
       "23   tpc-h  mongo   0.1        T1        Q1    1602   ms\n",
       "24   tpc-h  mongo   0.1        T1        Q8     254   ms\n",
       "25   tpc-h  mongo   0.1        T1       Q15     119   ms\n",
       "26   tpc-h  mongo   0.1        T1       Q20     407   ms\n",
       "27   tpc-h  mongo   0.1        T1       Q21    2046   ms\n",
       "28   tpc-h  mongo   0.1        T1       Q22    4132   ms\n",
       "29   tpc-h  mongo   0.1        T1        Q1    1606   ms\n",
       "..     ...    ...   ...       ...       ...     ...  ...\n",
       "265  tpc-h  mongo   1.0        T6       Q20   69954   ms\n",
       "266  tpc-h  mongo   1.0        T6       Q21   55117   ms\n",
       "267  tpc-h  mongo   1.0        T6       Q22   84589   ms\n",
       "268  tpc-h  mongo   1.0        T6       Q15   15465   ms\n",
       "269  tpc-h  mongo   1.0        T6        Q1  325275   ms\n",
       "270  tpc-h  mongo   1.0        T6        Q8   83817   ms\n",
       "271  tpc-h  mongo   1.0        T6       Q20   89752   ms\n",
       "272  tpc-h  mongo   1.0        T6       Q21   55608   ms\n",
       "273  tpc-h  mongo   1.0        T6       Q22   86394   ms\n",
       "274  tpc-h  mongo   1.0        T6       Q15   16812   ms\n",
       "275  tpc-h  mongo   1.0        T6       Q15   10563   ms\n",
       "276  tpc-h  mongo   1.0        T6        Q1  249321   ms\n",
       "277  tpc-h  mongo   1.0        T6        Q8   62561   ms\n",
       "278  tpc-h  mongo   1.0        T6       Q20   69955   ms\n",
       "279  tpc-h  mongo   1.0        T6       Q21   55134   ms\n",
       "280  tpc-h  mongo   1.0        T6       Q22   84533   ms\n",
       "281  tpc-h  mongo   1.0        T6       Q15   15453   ms\n",
       "282  tpc-h  mongo   1.0        T6        Q1  325324   ms\n",
       "283  tpc-h  mongo   1.0        T6        Q8   83812   ms\n",
       "284  tpc-h  mongo   1.0        T6       Q20   89756   ms\n",
       "285  tpc-h  mongo   1.0        T6       Q21   55610   ms\n",
       "286  tpc-h  mongo   1.0        T6       Q22   86377   ms\n",
       "287  tpc-h  mongo   1.0        T6       Q15   16793   ms\n",
       "288  tpc-h  mongo   2.0        T1       Q15   42953   ms\n",
       "289  tpc-h  mongo   2.0        T1        Q1  888742   ms\n",
       "290  tpc-h  mongo   2.0        T1        Q8  194269   ms\n",
       "291  tpc-h  mongo   2.0        T1       Q20  284587   ms\n",
       "292  tpc-h  mongo   2.0        T1       Q21  117424   ms\n",
       "293  tpc-h  mongo   2.0        T1       Q22  179180   ms\n",
       "294  tpc-h  mongo   2.0        T1       Q15   46968   ms\n",
       "\n",
       "[295 rows x 7 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "txt2xlsx('loadResults-Mongo.txt', ['bench', 'DB', 'scale', 'test-item', 'result', 'unit'])\n",
    "txt2xlsx('queryResults-Mongo.txt', ['bench', 'DB', 'scale', 'terminals', 'test-item', 'result', 'unit'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.5.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}
